{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Start Here","Farm Inputs","Cow Group Inputs","Hybrid Inputs-Results","Version Histiry","Calculations"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":61,"comments":4,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1904"}

{"sheet":"Start Here","index":0,"n_rows":108,"n_cols":1,"rows_kept":108,"cut":false,"hidden":false,"merged":[[0,1,5,2],[0,0,2,0]]}
["CornPicker® for Silage"]
[]
[]
["v. 1.05"]
["Mike Allen"]
["Department of Animal Science "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Click here to send comments or suggestions for future versions"]
[]
["CornPicker® for Silage article in Michigan Dairy Review"]
[]
["Michigan Corn Performance Trials"]

{"sheet":"Farm Inputs","index":1,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Farm specific inputs1"]
["Shrinkage/spoilage, % of DM",0.13]
["Feed refusals, %",0.03]
["Corn silage production cost, $/acre ",220]
["Corn silage harvest cost, $/ wet ton",4.5]
["Corn silage storage cost, $/ ton DM",26]
["Corn grain storage cost, $/ ton DM",0]
["Land rent equiv., $/ acre per year",120]
["Milk price, $/ 100 lb",14]
["Corn grain, dry ground, $/ ton as fed",125]
["Soybean meal 48%, $/ ton as fed",230]
["1assumed to be the same for all hybrids"]

{"sheet":"Cow Group Inputs","index":2,"n_rows":23,"n_cols":4,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["Cow group inputs"]
["Group ID (lactating only)1","Lactating #1","Lactating #2","Lactating #3"]
["Decription","Fresh","High","Low"]
["Number of animals in this group3",8,60,16]
["Dry Matter Intake, lb/ animal per day4",40,53,48]
["Forage NDF of diet, % of DM5",0.22,0.2,0.23]
["Corn silage, % of forage NDF6",0.66669999999999996,0.66669999999999996,0.66669999999999996]
["Diet cost, $/lb DM7",6.5000000000000002E-2,7.0000000000000007E-2,0.06]
["Milk yield response per unit of IVNDFD, lb 4% FCM/unit",0.55000000000000004,0.55000000000000004,0.55000000000000004]
[]
["Group ID (non-lactating only)2","Non-lactating #1","Non-lactating #2"]
["Decription","Far-off dry cows","Close-up dry cows"]
["Number of animals in this group3",10,6]
["Dry Matter Intake, lb/ animal per day4",30,27]
["Forage NDF of diet, % of DM5",0.26,0.23]
["Corn silage, % of forage NDF6",0.66669999999999996,0.66669999999999996]
[]
["Group ID (non-lactating only)2","Non-lactating #3","Non-lactating #4"]
["Decription","Heifers <12 months old","Heifers > 12 months old"]
["Number of animals in this group3",50,50]
["Dry Matter Intake, lb/ animal per day4",13,26]
["Forage NDF of diet, % of DM5",0.24,0.25]
["Corn silage, % of forage NDF6",0.66669999999999996,0.66669999999999996]

{"sheet":"Hybrid Inputs-Results","index":3,"n_rows":46,"n_cols":3,"rows_kept":46,"cut":false,"hidden":false,"merged":[[0,0,2,0],[0,1,5,2]]}
["CornPicker® for Silage"]
[]
[]
[{"$f":"'Start Here'!A4","v":"v. 1.05"}]
["Mike Allen"]
["Department of Animal Science "]
[null,"Defender","Challenger"]
["Company","Pioneer","Mycogen "]
["Hybrid","P0783XR","BMR09B67"]
[]
["Hybrid inputs"]
["Plant population, seeds/acre",30000,30000]
["Harvest dry matter (DM), %",0.32,0.32]
["Seed cost,  $/ bag",200,220]
["Number of kernels per bag",80000,80000]
["Yield of corn forage, tons of DM per acre (before ensiling)",8,8]
["In vitro neutral detergent fiber digestibility, % of NDF",0.6,0.68]
["Neutral detergent fiber, % of DM",0.38,0.42]
["Crude protein, % of DM",7.4999999999999997E-2,7.4999999999999997E-2]
[null,"Defender","Challenger"]
["Corn seed required, number of bags per year",{"$f":"B41*(B12/B15)","v":26.309723165443099},{"$f":"C41*(C12/C15)","v":24.29145277754715}]
["Amount of corn silage stored, tons of DM per year",{"$f":"Calculations!B16","v":561.27409419611945},{"$f":"Calculations!C16","v":518.2176592543392}]
["Differences from the Defender"]
["     Soybean meal, tons of DM per year",null,{"$f":"'Hybrid Inputs-Results'!C44","v":-2.1817426871569126}]
["     Corn grain, tons of DM per year",null,{"$f":"'Hybrid Inputs-Results'!C45","v":48.687310491978252}]
["     Milk yield, lb per year",null,{"$f":"(C17-B17)*100*365*(('Cow Group Inputs'!B4*'Cow Group Inputs'!B9*'Cow Group Inputs'!B7)+('Cow Group Inputs'!C4*'Cow Group Inputs'!C9*'Cow Group Inputs'!C7)+('Cow Group Inputs'!D4*'Cow Group Inputs'!D9*'Cow Group Inputs'!D7))","v":89940.496800000066}]
["     DMI to support milk yield, lb per year",null,{"$f":"-1*C26*0.33/0.76","v":-39053.110452631605}]
[null,"Defender","Challenger"]
["Seed corn cost, $/year",{"$f":"B21*B14","v":5261.9446330886194},{"$f":"C21*C14","v":5344.1196110603732}]
["Land cost, $/year",{"$f":"B41*'Farm Inputs'!B8","v":8419.1114129417911},{"$f":"C41*'Farm Inputs'!B8","v":7773.2648888150879}]
["Production cost, $/year",{"$f":"B41*'Farm Inputs'!B4","v":15435.037590393285},{"$f":"C41*'Farm Inputs'!B4","v":14250.985629494327}]
["Harvesting cost, $/year",{"$f":"(Calculations!B16*'Farm Inputs'!B5)/B13","v":7892.9169496329296},{"$f":"(Calculations!C16*'Farm Inputs'!B5)/C13","v":7287.435833264145}]
["Corn silage storage cost, $/year",{"$f":"Calculations!B16*'Farm Inputs'!B6","v":14593.126449099105},{"$f":"(Calculations!C16*'Farm Inputs'!B6)","v":13473.659140612819}]
["Differences from the Defender"]
["     Corn grain storage cost, $/year","->",{"$f":"C25*'Farm Inputs'!B7","v":0}]
["     Soybean meal, $/year","->",{"$f":"C24*'Farm Inputs'!B11/0.9","v":-557.5564644956554}]
["     Corn grain, $/year","->",{"$f":"C25*'Farm Inputs'!B10/0.9","v":6762.1264572192013}]
["     Milk yield difference, $/year","->",{"$f":"IF(C17-B17>0,-1*C26*'Farm Inputs'!B9/100,-1*C26*'Farm Inputs'!B9/100)","v":-12591.669552000008}]
["     Feed costs (not incl. corn silage), $/year","->",{"$f":"IF(C17-B17>0,(-1*C27*Calculations!C17)+(Calculations!B29-Calculations!C29),(-1*C27*Calculations!C17)-(Calculations!B29-Calculations!C29))","v":1683.0671474324447}]
[null,"Defender","Challenger"]
["Land required for corn silage production, acres per year",{"$f":"Calculations!B16/B16","v":70.159261774514931},{"$f":"Calculations!C16/C16","v":64.7772074067924}]
["Partial budget cost for corn silage production, $/year",{"$f":"SUM(B29:B33)","v":51602.137035155727},{"$f":"C29+C30+C31+C32+C33+C35+C36+C37+C38+C39","v":43425.432691402741}]
["Solver:"]
[{"$f":"C44+C45","v":46.505567804821339},{"$f":"Calculations!C12","v":46.505567804821339},-2.1817426871569126]
[{"$f":"0.499*C44+0.094*C45","v":3.4879175853546562},{"$f":"Calculations!C15","v":3.4879175853616005},48.687310491978252]
["Profit advantage for Challenger compared to Defender, $ /year =>",null,{"$f":"B42-C42","v":8176.7043437529865}]

{"sheet":"Version Histiry","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Calculations","index":5,"n_rows":29,"n_cols":3,"rows_kept":29,"cut":false,"hidden":true,"merged":[]}
["Corn silage intake, tons DM/year"]
["Lactating #1",{"$f":"('Cow Group Inputs'!B4*365*'Cow Group Inputs'!B5*'Cow Group Inputs'!B6*'Cow Group Inputs'!B7)/'Hybrid Inputs-Results'!B18/2000","v":22.541477894736843}]
["Lactating #2",{"$f":"('Cow Group Inputs'!C4*365*'Cow Group Inputs'!C5*'Cow Group Inputs'!C6*'Cow Group Inputs'!C7)/'Hybrid Inputs-Results'!B18/2000","v":203.64176052631578}]
["Lactating #3",{"$f":"('Cow Group Inputs'!D4*365*'Cow Group Inputs'!D5*'Cow Group Inputs'!D6*'Cow Group Inputs'!D7)/'Hybrid Inputs-Results'!B18/2000","v":56.558617263157899}]
["Dry #1",{"$f":"('Cow Group Inputs'!B13*365*'Cow Group Inputs'!B14*'Cow Group Inputs'!B15*'Cow Group Inputs'!B16)/'Hybrid Inputs-Results'!B18/2000","v":24.974932894736842}]
["Dry #2",{"$f":"('Cow Group Inputs'!C13*365*'Cow Group Inputs'!C14*'Cow Group Inputs'!C15*'Cow Group Inputs'!C16)/'Hybrid Inputs-Results'!B18/2000","v":11.930333328947368}]
["Heifers #1",{"$f":"('Cow Group Inputs'!B20*365*'Cow Group Inputs'!B21*'Cow Group Inputs'!B22*'Cow Group Inputs'!B23)/'Hybrid Inputs-Results'!B18/2000","v":49.949865789473684}]
["Heifers #2",{"$f":"('Cow Group Inputs'!C20*365*'Cow Group Inputs'!C21*'Cow Group Inputs'!C22*'Cow Group Inputs'!C23)/'Hybrid Inputs-Results'!B18/2000","v":104.06222039473683}]
["Total",{"$f":"B2+B3+B4+B5+B6+B7+B8","v":473.65920809210525}]
[null,"Defender","Challenger"]
["Corn silage fed, tons DM/year",{"$f":"B9/(1-'Farm Inputs'!B3)","v":488.30846195062395},{"$f":"B11*('Hybrid Inputs-Results'!B18/'Hybrid Inputs-Results'!C18)","v":441.80289414580261}]
["Difference, tons DM/year",null,{"$f":"B11-C11","v":46.505567804821339}]
["Corn silage NDF, tons DM/year",{"$f":"B11*'Hybrid Inputs-Results'!B18","v":185.5572155412371},{"$f":"C11*'Hybrid Inputs-Results'!C18","v":185.5572155412371}]
["Corn silage CP, tons DM/year",{"$f":"B11*'Hybrid Inputs-Results'!B19","v":36.623134646296798},{"$f":"C11*'Hybrid Inputs-Results'!C19","v":33.135217060935197}]
["Difference, tons DM/year",null,{"$f":"B14-C14","v":3.4879175853616005}]
["Corn silage harvested, tons DM/year",{"$f":"B11/(1-'Farm Inputs'!B2)+B27","v":561.27409419611945},{"$f":"C11/(1-'Farm Inputs'!B2)+C27","v":518.2176592543392}]
["Average lactating diet cost, $/lb",null,{"$f":"('Cow Group Inputs'!B4*'Cow Group Inputs'!B5*'Cow Group Inputs'!B8+'Cow Group Inputs'!C4*'Cow Group Inputs'!C5*'Cow Group Inputs'!C8+'Cow Group Inputs'!D4*'Cow Group Inputs'!D5*'Cow Group Inputs'!D8)/('Cow Group Inputs'!B4*'Cow Group Inputs'!B5+'Cow Group Inputs'!C4*'Cow Group Inputs'!C5+'Cow Group Inputs'!D4*'Cow Group Inputs'!D5)","v":6.7825679475164019E-2}]
["DMI to support increased milk yield, lb per cow/year",null,{"$f":"('Hybrid Inputs-Results'!C17-'Hybrid Inputs-Results'!B17)*100*0.55*(0.3/0.76)*365","v":633.94736842105317}]
[]
["Corn silage (harvested) required for difference in milk yield"]
["Lactating #1, lb DM/year",{"$f":"('Cow Group Inputs'!B4*'Cow Group Inputs'!B6*'Cow Group Inputs'!B7*C18)/('Hybrid Inputs-Results'!C18)/(1-'Farm Inputs'!B3)/(1-'Farm Inputs'!B2)","v":2098.7274799155748}]
["Lactating #2, lb DM/year",{"$f":"('Cow Group Inputs'!C4*'Cow Group Inputs'!C6*'Cow Group Inputs'!C7*C18)/('Hybrid Inputs-Results'!C18)/(1-'Farm Inputs'!B3)/(1-'Farm Inputs'!B2)","v":14309.505544878917}]
["Lactating #3, lb DM/year",{"$f":"('Cow Group Inputs'!D4*'Cow Group Inputs'!D6*'Cow Group Inputs'!D7*C18)/('Hybrid Inputs-Results'!C18)/(1-'Farm Inputs'!B3)/(1-'Farm Inputs'!B2)","v":4388.248367096201}]
["Total, lb DM/year",{"$f":"B21+B22+B23","v":20796.481391890695}]
["Total, tons DM/year",{"$f":"B24/2000","v":10.398240695945347}]
[null,"Defender","Challenger"]
["Harvested CS adjustment, tons",{"$f":"IF(B25<0,B25,0)","v":0},{"$f":"IF(B25>0,B25,0)","v":10.398240695945347}]
["Corn silage cost, $/ton DM harvested",{"$f":"('Hybrid Inputs-Results'!B29+'Hybrid Inputs-Results'!B30+'Hybrid Inputs-Results'!B31+'Hybrid Inputs-Results'!B32+'Hybrid Inputs-Results'!B33)/B16","v":91.937499999999986},{"$f":"('Hybrid Inputs-Results'!C29+'Hybrid Inputs-Results'!C30+'Hybrid Inputs-Results'!C31+'Hybrid Inputs-Results'!C32+'Hybrid Inputs-Results'!C33)/C16","v":92.875}]
["CS adjustment for feed cost",{"$f":"B27*B28","v":0},{"$f":"C27*C28","v":965.7366046359241}]